{include: include/head}
<div class="head_box">
<table width="100%" cellpadding="5" cellspacing="1">
    <tr>
    <td class="head_left"><b>{$LANG['database.list']}</b></td>
    <td class="head_center"> </td>
    <td align="right" class="head_right"><a href="?_lib={$_lib}&_file={$_file}&_act=sql">{$LANG['database.dosql']}</a></td>
    </tr>
</table>
</div>

<form class="form_list" name="f1" method="post" action="action.php" onsubmit="return (this.batchtype.value != '');">
<div class="list_box">
<table width="100%" cellpadding="5" cellspacing="1">
    <tr class="box_title"><td><input name="select_all" type="checkbox" onclick="selectAll(this);" /></td><td>{$LANG['database.table']}</td><td>{$LANG['database.rownum']}</td><td>{$LANG['database.engine']}</td><td>{$LANG['database.collation']}</td><td>{$LANG['database.datalen']}</td><td>{$LANG['database.freelen']}</td><td>{$LANG['field_action']}</td></tr>
    {php: $arr = SQL("SHOW TABLE STATUS", true); foreach($arr as $rs){}
    <tr align="center"><td><input name="selectme[]" type="checkbox" value="{$rs['Name']}" /></td><td align="left">{$rs['Name']}</td><td>{$rs['Rows']}</td><td>{$rs['Engine']}</td><td>{$rs['Collation']}</td><td>{get_size($rs['Data_length'] + $rs['Index_length'])}</td><td>{get_size($rs['Data_free'])}</td><td><a href="javascript:openDiv(this, '?_dir=ajax&_file=db_struct&table={$rs['Name']}', 400, 350);">{$LANG['database.struct']}</a></td></tr>
    {php: }}
</table>
</div>

<div class="page_box">
<table width="100%" cellpadding="5" cellspacing="1">
    <tr><td><select name="batchtype" onchange="var val=this.value;var obj=$E('bakdir');if(val=='restore' || val=='delbak'){obj.style.display='';}else{obj.style.display='none';}">
    <option value="">{$LANG['please_select']}</option>
    <option value="backup">{$LANG['database.backup']}</option>
    <option value="restore">{$LANG['database.restore']}</option>
    <option value="clear">{$LANG['database.clear']}</option>
    <option value="check">{$LANG['database.check']}</option>
    <option value="optimize">{$LANG['database.optimize']}</option>
    <option value="repair">{$LANG['database.repair']}</option>
    <option value="analyze">{$LANG['database.analyze']}</option>
    <option value="delbak">{$LANG['database.delbak']}</option>
    </select>
    <select name="bakdir" style="display:none">
    <?php
    $path = DAT.'/backup_db/';
	if($handle = opendir($path)){
		while(false !== ($bakdir = readdir($handle))){
		    if($bakdir != "." && $bakdir != ".." && is_dir($path . $bakdir)) echo '<option value="'.$bakdir.'">'. substr($bakdir, 0, 10) .'</option>';
		}
		
		closedir($handle);
	}
    ?>
    </select>
    <input type="submit" value="{$LANG['button_submit']}" /></td><td align="right"></td></tr>
</table>
</div>
{__FORM()}
<input type="hidden" name="_act" value="do_batch" />
</form>
{include: include/foot}